SDO_GEOMETRY
The geometry type of an XFM feature is determined dynamically during registration in OpenCities Geospatial Administrator. This is done by looking at the Oracle Spatial spatial index defined for the geometry table.
For example, a point spatial index:
CREATE INDEX hydrants_idx ON hydrants(Geometry) INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2 PARAMETERS ('layer_gtype=point');
| Oracle Spatial Index Type |
XFM Feature Type |
|---|---|
| 'layer_gtype=point' |
Point-Cell or Point-Text depending on user input; can be rotated |
| 'layer_gtype=multipoint' |
Point-Cell Collection or Point-Text Collection; cannot be rotated |
| 'layer_gtype=curve' |
Linestring |
| 'layer_gtype=multicurve' |
Linestring Collection |
| 'layer_gtype=polygon' |
Polygon Collection |
| 'layer_gtype=multipolygon' |
Polygon Collection |
| 'layer_gtype=collection' or not specified |
The first in the table determines geometry type |
| No index |
The first in the table determines geometry type |